﻿CREATE TABLE [dbo].[CommonNotice] (
    [Id]          INT           IDENTITY (1, 1) NOT NULL,
    [NoticeType]  INT           NULL,
    [PatientId]   NVARCHAR (50) NULL,
    [CardNo]      NVARCHAR (50) NULL,
    [Name]        NVARCHAR (50) NULL,
    [NoticeTime]  DATETIME      NULL,
    [AppNo]       NVARCHAR (50) NULL,
    [ClinicNo]    NVARCHAR (50) NULL,
    [CreateTime]  DATETIME      NULL,
    [IsProcessed] INT           CONSTRAINT [DF__CommonNot__IsPro__07020F21] DEFAULT ((0)) NULL,
    [ProcessTime] DATETIME      NULL,
    CONSTRAINT [PK__CommonNo__3214EC070519C6AF] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'0-缴费，1-检验，2-检查', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'NoticeType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'患者ID，（院内唯一）', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'PatientId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'就诊卡号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'CardNo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'患者姓名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'Name';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'通知时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'NoticeTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'如果NoticeType为1，2时，必填', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'AppNo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'就诊流水号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'ClinicNo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'创建时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'CreateTime';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否已处理，1：已处理，0：未处理', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'IsProcessed';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'处理时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'CommonNotice', @level2type = N'COLUMN', @level2name = N'ProcessTime';

